package com.tust.dao;

import com.tust.domain.Student;
import org.apache.ibatis.annotations.Param;

import java.util.List;

public interface StudentDao {
    int insertStudent(Student student);
    int deleteStudent(@Param("studentNum") String studentNum);
    int updateStudent(@Param("oldStudentNum") String oldStudentNum, @Param("student") Student student);
    List<Student> selectStudentByStudentNum(@Param("studentNum") String studentNum);
    List<Student> selectStudentByStudentName(@Param("studentName") String studentName);
    List<Student> selectStudentByStudentSex(@Param("studentSex") String studentSex);
    List<Student> selectStudentByStudentSdept(@Param("studentSdept") String studentSdept);
    List<Student> selectStudentByStudentMajor(@Param("studentMajor") String studentMajor);
    List<Student> selectStudentByStudentClassNum(@Param("studentClassNum") String studentClassNum);
    List<Student> selectStudentAll();
}
